﻿<%@ Page Title="" Language="vb" AutoEventWireup="false" MasterPageFile="~/Site.Master" CodeBehind="INSTALACION.aspx.vb" Inherits="IMSS.SA.Formulario_web18" %>
<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" runat="server">
    <style type="text/css">
    .style2
    {
        text-align: center;
    }
    .style3
    {
        text-align: center;
    }
        .style4
        {
            text-align: center;
            width: 16px;
        }
        .style5
        {
            text-align: center;
            width: 306px;
        }
    </style>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">
    <table style="width:100%; color: #FFFFFF; background-color: #006699; background-image: url('../Styles/r3.PNG'); background-repeat: no-repeat;">
    <tr>
        <td class="style4">
            &nbsp;</td>
        <td class="style3" colspan="2">
            &nbsp;</td>
    </tr>
    <tr>
        <td class="style4">
            &nbsp;</td>
        <td class="style3" colspan="2">
            <asp:Label ID="Label1" runat="server" Text="Label" Visible="False"></asp:Label>
        </td>
    </tr>
    <tr>
        <td class="style4">
            &nbsp;</td>
        <td class="style3" colspan="2">
            &nbsp;</td>
    </tr>
    <tr>
        <td class="style4">
            &nbsp;</td>
        <td class="style3" colspan="2">
            INGRESAR DATOS DE INSTALACION</td>
    </tr>
    <tr>
        <td class="style4">
            &nbsp;</td>
        <td class="style3" colspan="2">
            &nbsp;</td>
    </tr>
    <tr>
        <td class="style4">
            &nbsp;</td>
        <td class="style5">
            ID_INSTALACION</td>
        <td class="style2">
            <asp:TextBox ID="TexINSTALACION" runat="server" MaxLength="15"></asp:TextBox>
        </td>
    </tr>
    <tr>
        <td class="style4">
            &nbsp;</td>
        <td class="style5">
            ID_SERVICIO</td>
        <td class="style2">
            <asp:TextBox ID="TexSERVICIO" runat="server" MaxLength="15"></asp:TextBox>
        </td>
    </tr>
    <tr>
        <td class="style4">
            &nbsp;</td>
        <td class="style5">
            FECHA</td>
        <td class="style2">
            <asp:TextBox ID="TexFECHA" runat="server" MaxLength="15"></asp:TextBox>
        </td>
    </tr>
    <tr>
        <td class="style4">
            &nbsp;</td>
        <td class="style5">
            &nbsp;</td>
        <td class="style2">
            &nbsp;</td>
    </tr>
    <tr>
        <td class="style4">
            &nbsp;</td>
        <td class="style5">
            <asp:Button ID="ENVIAR" runat="server" Text="ENVIAR" />
        </td>
        <td class="style2">
            <asp:Button ID="BORRAR" runat="server" Text="BORRAR" />
        </td>
    </tr>
    <tr>
        <td class="style4">
            &nbsp;</td>
        <td class="style5">
            &nbsp;</td>
        <td>
            &nbsp;</td>
    </tr>
    <tr>
        <td class="style4">
            &nbsp;</td>
        <td class="style2" colspan="2">
            &nbsp;</td>
    </tr>
    <tr>
        <td class="style4">
            &nbsp;</td>
        <td class="style2" colspan="2">
            <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
                DataKeyNames="Id_instalacion" DataSourceID="SqlDataSource1" Width="768px">
                <Columns>
                    <asp:BoundField DataField="Id_instalacion" HeaderText="Id_instalacion" 
                        ReadOnly="True" SortExpression="Id_instalacion" />
                    <asp:BoundField DataField="Id_servicio" HeaderText="Id_servicio" 
                        SortExpression="Id_servicio" />
                    <asp:BoundField DataField="Fecha" HeaderText="Fecha" SortExpression="Fecha" />
                </Columns>
            </asp:GridView>
            <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
                ConnectionString="<%$ ConnectionStrings:IMSS.SAConnectionString13 %>" 
                DeleteCommand="DELETE FROM [INSTALACION] WHERE [Id_instalacion] = @Id_instalacion" 
                InsertCommand="INSERT INTO [INSTALACION] ([Id_instalacion], [Id_servicio], [Fecha]) VALUES (@Id_instalacion, @Id_servicio, @Fecha)" 
                SelectCommand="SELECT [Id_instalacion], [Id_servicio], [Fecha] FROM [INSTALACION]" 
                UpdateCommand="UPDATE [INSTALACION] SET [Id_servicio] = @Id_servicio, [Fecha] = @Fecha WHERE [Id_instalacion] = @Id_instalacion">
                <DeleteParameters>
                    <asp:Parameter Name="Id_instalacion" Type="String" />
                </DeleteParameters>
                <InsertParameters>
                    <asp:ControlParameter ControlID="TexINSTALACION" Name="Id_instalacion" 
                        PropertyName="Text" Type="String" />
                    <asp:ControlParameter ControlID="TexSERVICIO" Name="Id_servicio" 
                        PropertyName="Text" Type="String" />
                    <asp:ControlParameter ControlID="TexFECHA" DbType="Date" Name="Fecha" 
                        PropertyName="Text" />
                </InsertParameters>
                <UpdateParameters>
                    <asp:Parameter Name="Id_servicio" Type="String" />
                    <asp:Parameter DbType="Date" Name="Fecha" />
                    <asp:Parameter Name="Id_instalacion" Type="String" />
                </UpdateParameters>
            </asp:SqlDataSource>
        </td>
    </tr>
    <tr>
        <td class="style4">
            &nbsp;</td>
        <td class="style2" colspan="2">
            &nbsp;</td>
    </tr>
    <tr>
        <td class="style4">
            &nbsp;</td>
        <td class="style5">
            &nbsp;</td>
        <td>
            &nbsp;</td>
    </tr>
    <tr>
        <td class="style4">
            &nbsp;</td>
        <td class="style5">
            &nbsp;</td>
        <td>
            &nbsp;</td>
    </tr>
    <tr>
        <td class="style4">
            &nbsp;</td>
        <td class="style5">
            &nbsp;</td>
        <td>
            &nbsp;</td>
    </tr>
</table>
</asp:Content>
